-- manual changes in Invoice_BankRemit Table BankID = int, EPRC = 100 length BEGIN TRANSACTION ALTER TABLE dbo.Invoice_BankPacking ADD RateType varchar(30) NULL, PRemarks varchar(50) NULL, PAmount numeric(15, 4) NOT NULL CONSTRAINT DF_Invoice_BankPacking_PAmount DEFAULT 0 GO COMMIT